HTML FORMS selected question

------=_Part_5708_1990230.1165185756003
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I am having trouble getting values populated in my form... Here is what I
got so far:

//The values that need to be selected
$result_ip=pg_query($dbconn,$test_query);


//This will show ALL values.
while($rows=pg_fetch_array($result)){
foreach ($options as $index => $option) {
if ($rows[1]==$option)
{
echo "$rows[1]
\n";
break;
}
else
{
echo "$rows[1] \n";
break;
}
}
}

What am I doing wrong?

TIA!

------=_Part_5708_1990230.1165185756003
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I am having trouble getting values populated in my form... Here is what I got so far:

//The values that need to be selected
$result_ip=pg_query($dbconn,$test_query);

<SELECT    NAME="ip[]" SIZE=10 MULTIPLE>

<?php
//This will show ALL values.
while($rows=pg_fetch_array($result)){
foreach ($options as $index => $option) {
    if ($rows[1]==$option)
    {
echo "<OptioN VALUE=\"$rows[0]\" selected=\"selected\">$rows[1]</Option> \n";

break;
        }
else
{
    echo "<OPTION VALUE=\"$rows[0]\">$rows[1]</OPTION> \n";
    break;
}
}
}

What am I doing wrong?

TIA!



------=_Part_5708_1990230.1165185756003--

Re: HTML FORMS selected question

am 04.12.2006 00:08:09 von Chris

Mag Gam wrote:
> I am having trouble getting values populated in my form... Here is what
> I got so far:
>
> //The values that need to be selected
> $result_ip=pg_query($dbconn,$test_query);
>
>

> > //This will show ALL values.
> while($rows=pg_fetch_array($result)){
> foreach ($options as $index => $option) {
> if ($rows[1]==$option)
> {


What does $rows contain? What does $options contain?

You could also simplify this a little bit. I'd at least remove the
foreach $options loop and use "in_array" - see php.net/in_array

while ($rows = pg_fetch_array($result)) {
$selected = '';
if (in_array($rows[1], $options)) {
$selected = ' SELECTED';
}
sprintf('%s', $rows[1], $selected,
$rows[1]);
}

--
Postgresql & php tutorials
http://www.designmagick.com/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: HTML FORMS selected question

Please CC the list so they can suggest things and learn as well.

Mag Gam wrote:
> Hi Chris:
>
> $rows is an array of all the values
> $options is an array of all the values selected

I meant can you give an example of what they both contain?

I know what they *should* contain - what do they *actually* contain?

--
Postgresql & php tutorials
http://www.designmagick.com/

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: HTML FORMS selected question

Maybe it's just a typo, but your pg_query is returning into the var
$result_ip, while your fetch is referencing var $result (without _ip).
Maybe that's just a typo for your question, but if not, that is at least one
error.

Also, it would be helpful to know what error you're getting....

Randy Moller

-----Original Message-----
From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org]
On Behalf Of Chris
Sent: Sunday, December 03, 2006 4:08 PM
To: Mag Gam
Cc: pgsql-php@postgresql.org
Subject: Re: [PHP] HTML FORMS selected question

Mag Gam wrote:
> I am having trouble getting values populated in my form... Here is what
> I got so far:
>
> //The values that need to be selected
> $result_ip=pg_query($dbconn,$test_query);
>
>
> > //This will show ALL values.
> while($rows=pg_fetch_array($result)){
> foreach ($options as $index => $option) {
> if ($rows[1]==$option)
> {


What does $rows contain? What does $options contain?

You could also simplify this a little bit. I'd at least remove the
foreach $options loop and use "in_array" - see php.net/in_array

while ($rows = pg_fetch_array($result)) {
$selected = '';
if (in_array($rows[1], $options)) {
$selected = ' SELECTED';
}
sprintf('%s', $rows[1], $selected,
$rows[1]);
}

--
Postgresql & php tutorials
http://www.designmagick.com/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: 12/2/2006
9:39 PM


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: 12/2/2006
9:39 PM



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: HTML FORMS selected question

am 04.12.2006 00:43:31 von Mag Gam

------=_Part_5876_15160297.1165189411076
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Randy + Chris:

Thx for the quick replies!

Chris:

$rows contain ip addresses (postgresql inet) type (example: 192.168.0.1)
$options contain ip addresses (postgresql inet0 type (example: 127.0.0.1)
(keep in mind) they are both arrays. $rows contact all ips, and $options
contact the ip addresses that were selected

Randy:
I am not sure what you mean. The variables look right. I am getting no
errors! Just the logic is messed up.

HTH




On 12/3/06, Randy Moller wrote:
>
> Maybe it's just a typo, but your pg_query is returning into the var
> $result_ip, while your fetch is referencing var $result (without _ip).
> Maybe that's just a typo for your question, but if not, that is at least
> one
> error.
>
> Also, it would be helpful to know what error you're getting....
>
> Randy Moller
>
> -----Original Message-----
> From: pgsql-php-owner@postgresql.org [mailto:
> pgsql-php-owner@postgresql.org]
> On Behalf Of Chris
> Sent: Sunday, December 03, 2006 4:08 PM
> To: Mag Gam
> Cc: pgsql-php@postgresql.org
> Subject: Re: [PHP] HTML FORMS selected question
>
> Mag Gam wrote:
> > I am having trouble getting values populated in my form... Here is what
> > I got so far:
> >
> > //The values that need to be selected
> > $result_ip=pg_query($dbconn,$test_query);
> >
> >

> > > > //This will show ALL values.
> > while($rows=pg_fetch_array($result)){
> > foreach ($options as $index => $option) {
> > if ($rows[1]==$option)
> > {
>
>
> What does $rows contain? What does $options contain?
>
> You could also simplify this a little bit. I'd at least remove the
> foreach $options loop and use "in_array" - see php.net/in_array
>
> while ($rows = pg_fetch_array($result)) {
> $selected = '';
> if (in_array($rows[1], $options)) {
> $selected = ' SELECTED';
> }
> sprintf('%s', $rows[1], $selected,
> $rows[1]);
> }
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: 12/2/2006
> 9:39 PM
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: 12/2/2006
> 9:39 PM
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

------=_Part_5876_15160297.1165189411076
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Randy + Chris:

Thx for the quick replies!

Chris:

$rows contain ip addresses (postgresql inet) type (example: )
$options contain ip addresses (postgresql inet0 type (example:
)
(keep in mind) they are both arrays. $rows contact all ips, and $options contact the ip addresses that were selected

Randy:
I am not sure what you mean. The variables look right. I am getting no errors! Just the logic is messed up.


HTH

Re: HTML FORMS selected question

Mag Gam wrote:
> Randy + Chris:
>
> Thx for the quick replies!
>
> Chris:
>
> $rows contain ip addresses (postgresql inet) type (example: 192.168.0.1
> )
> $options contain ip addresses (postgresql inet0 type (example: 127.0.0.1
> )
> (keep in mind) they are both arrays. $rows contact all ips, and $options
> contact the ip addresses that were selected
>
> Randy:
> I am not sure what you mean. The variables look right. I am getting no
> errors! Just the logic is messed up.

I think Randy's right.

At the top you have:

//The values that need to be selected
$result_ip=pg_query($dbconn,$test_query);
^^^^^^^^^
but you are doing this:

while ($row = pg_fetch_array($result)) {


$result_ip at the top, $result in the second bit.


If you don't see errors, turn up error reporting & display errors:

error_reporting(E_ALL);
ini_set('display_errors', true);


Also that's not what I meant. I meant add a var_dump or print_r at each
stage to see what you are *really* getting from the code.


--
Postgresql & php tutorials
http://www.designmagick.com/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: HTML FORMS selected question

------=_Part_5924_16292896.1165190445596
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Chris + Randy:

Sorry, I may of forgetten to give you this:
$result = pg_query($dbconn, "select id,address from ip");

This is right before the:
$options=pg_fetch_array($result_ip);

so, my $results is really all the ip addresses ($rows after I perform the
pg_fetch_array).

I will add the var_dump to see it (never done it before, I will do some
googling :) )






On 12/3/06, Chris wrote:
>
> Mag Gam wrote:
> > Randy + Chris:
> >
> > Thx for the quick replies!
> >
> > Chris:
> >
> > $rows contain ip addresses (postgresql inet) type (example: 192.168.0.1
> > )
> > $options contain ip addresses (postgresql inet0 type (example: 127.0.0.1
> > )
> > (keep in mind) they are both arrays. $rows contact all ips, and $options
> > contact the ip addresses that were selected
> >
> > Randy:
> > I am not sure what you mean. The variables look right. I am getting no
> > errors! Just the logic is messed up.
>
> I think Randy's right.
>
> At the top you have:
>
> //The values that need to be selected
> $result_ip=pg_query($dbconn,$test_query);
> ^^^^^^^^^
> but you are doing this:
>
> while ($row = pg_fetch_array($result)) {
>
>
> $result_ip at the top, $result in the second bit.
>
>
> If you don't see errors, turn up error reporting & display errors:
>
> error_reporting(E_ALL);
> ini_set('display_errors', true);
>
>
> Also that's not what I meant. I meant add a var_dump or print_r at each
> stage to see what you are *really* getting from the code.
>
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>

------=_Part_5924_16292896.1165190445596
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Chris + Randy:

Sorry, I may of forgetten to give you this:
$result = pg_query($dbconn, "select id,address from ip");

This is right before the:
$options=pg_fetch_array($result_ip);

so, my $results is really all the ip addresses ($rows after I perform the pg_fetch_array).


I will add the var_dump to see it (never done it before, I will do some googling :) )

Re: HTML FORMS selected question

This is a multi-part message in MIME format.

------=_NextPart_000_001E_01C716FF.BDB696C0
Content-Type: text/plain;
charset="windows-1250"
Content-Transfer-Encoding: quoted-printable

Ok, I think you are misunderstanding the process:

=20

1. first, you are querying a database (I assume a postgres db) like
this:

=20

$result =3D pg_query($dbconn, =93select…”) , so,

=20

$result now is a =93resource reference=94 which contains the =
=93result=94 of the
query. However, now you need to tell php to return the contents of that
resource to you (you can return in either an indexed, associative, or =
object
array). So, to get your =93array=94, you now use $result like this:

=20

$myArray =3D pg_fetch_array($result);

=20

Now $myArray is the actual =93row/s=94 you returned in $result.

=20

Does that make sense?

=20

So, when you first query, $result (or $result_ip) =3D pg_query(conn, =
sql), you
need to be consistent with your variables. Either use $result_ip, or
$result, but not both=85.My guess is that=92s your problem.

=20

Hope that helps!

Randy

_____ =20

From: pgsql-php-owner@postgresql.org =
[mailto:pgsql-php-owner@postgresql.org]
On Behalf Of Mag Gam
Sent: Sunday, December 03, 2006 5:01 PM
To: Chris
Cc: Randy Moller; pgsql-php@postgresql.org
Subject: Re: [PHP] HTML FORMS selected question

=20

Chris + Randy:

Sorry, I may of forgetten to give you this:
$result =3D pg_query($dbconn, "select id,address from ip");

This is right before the:
$options=3Dpg_fetch_array($result_ip);

so, my $results is really all the ip addresses ($rows after I perform =
the
pg_fetch_array).=20

I will add the var_dump to see it (never done it before, I will do some
googling :) )







On 12/3/06, Chris dmagick@gmail.com>
wrote:

Mag Gam wrote:
> Randy + Chris:
>
> Thx for the quick replies!=20
>
> Chris:
>
> $rows contain ip addresses (postgresql inet) type (example: HYPERLINK
"http://192.168.0.1"192.168.0.1
> )
> $options contain ip addresses (postgresql inet0 type (example: =
HYPERLINK
"http://127.0.0.1"127.0.0.1
> )
> (keep in mind) they are both arrays. $rows contact all ips, and =
$options
> contact the ip addresses that were selected=20
>
> Randy:
> I am not sure what you mean. The variables look right. I am getting no
> errors! Just the logic is messed up.

I think Randy's right.

At the top you have:

//The values that need to be selected=20
$result_ip=3Dpg_query($dbconn,$test_query);
^^^^^^^^^
but you are doing this:

while ($row =3D pg_fetch_array($result)) {


$result_ip at the top, $result in the second bit.


If you don't see errors, turn up error reporting & display errors:=20

error_reporting(E_ALL);
ini_set('display_errors', true);


Also that's not what I meant. I meant add a var_dump or print_r at each
stage to see what you are *really* getting from the code.


--
Postgresql & php tutorials
HYPERLINK "http://www.designmagick.com/"http://www.designmagick.com/

=20

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: =
12/2/2006
9:39 PM


--=20
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: =
12/2/2006
9:39 PM
=20

------=_NextPart_000_001E_01C716FF.BDB696C0
Content-Type: text/html;
charset="windows-1250"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dwindows-1250">

--

No virus found in this outgoing message.

Checked by AVG Free Edition.

Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: =
12/2/2006 9:39 PM

Re: HTML FORMS selected question

Mag Gam wrote:
> Chris + Randy:
>
> Sorry, I may of forgetten to give you this:
> $result = pg_query($dbconn, "select id,address from ip");
>
> This is right before the:
> $options=pg_fetch_array($result_ip);
>
> so, my $results is really all the ip addresses ($rows after I perform
> the pg_fetch_array).
>
> I will add the var_dump to see it (never done it before, I will do some
> googling :) )

After your query add it:

$result = pg_query(....)
var_dump($result);

if that's not a "resource" then you have a problem with your query. Use
pg_last_error to work it out.


Inside your loop, add it:

while ($row = pg_fetch_array($result)) {
var_dump($row);
}

--
Postgresql & php tutorials
http://www.designmagick.com/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: HTML FORMS selected question

--0-436170247-1165255151=:11557
Content-Type: text/plain; charset=ascii
Content-Transfer-Encoding: quoted-printable

----- Original Message ----=0AFrom: Mag Gam =0ATo: pgsq=
l-php@postgresql.org=0ASent: Sunday, December 3, 2006 2:42:36 PM=0ASubject:=
[PHP] HTML FORMS selected question I am having trouble getting values=
populated in my form... Here is what I got so far: //The values that =
need to be selected=0A$result_ip=3Dpg_query($dbconn,$test_query); ECT NAME=3D"ip[]" SIZE=3D10 MULTIPLE> values.=0Awhile($rows=3Dpg_fetch_array($result)){=0Aforeach ($options as $=
index =3D> $option) {=0A if ($rows[1]==$option)=0A {=0Aecho " ioN VALUE=3D\"$rows[0]\" selected=3D\"selected\">$rows[1] \n"; =0A=
=0Abreak;=0A }=0Aelse=0A{=0A echo "$=
rows[1] \n"; =0A break;=0A}=0A}=0A} What am I doing wrong?=
TIA! --------------------------- Mag, i'm not sure what is =
wrong with the specific code, however, i'll make a suggestion that i think =
will help you more than just resolving this issue. i recommend you loo=
k into learning a forms class. the code will be much cleaner and the thoug=
ht process is much more obvious. the icing on the cake is the increased fu=
nctionality you will get "out of the box" because some smart person coded i=
t right into their forms class. for example, i get client side and server =
side error checking and error message reporting. i also get to have my for=
m give focus to the first element via javascript. there is some ajaxy stuf=
f i haven't learned yet, but it is available. i use Manuel Lemos' free=
forms generation and validation class which can be found on phpclasses.org=
.. iirc, the license is such that it can be included in proprietary commerc=
ial applications. there are others, too. i believe pear has one, along wi=
th some other functionality. i'm very glad i went with a forms class i=
nstead of "htmling" it all. i think you will be, too. Manuel has a ya=
hoo mailing list that is very helpful and reasonably active. Most question=
s are answered within a day or so. good luck. =0A___=
____________________________________________________________ _______________=
______=0ADo you Yahoo!?=0AEveryone is raving about the all-new Yahoo! Mail =
beta.=0Ahttp://new.mail.yahoo.com
--0-436170247-1165255151=:11557
Content-Type: text/html; charset=ascii
Content-Transfer-Encoding: quoted-printable

ad>